restore vt. 1.拿回原處,恢復原狀;復舊;恢復;復活,復興,再興(制度、習慣等),使復位,使復職,使復辟。 2.歸還。 3.修理,修補,重建,修復;再造,復原(古生物),補正,校補(書籍中的缺失文字等)。 4.使恢復健康[元氣],使恢復意識。 restore order 恢復秩序。 restore to its owner (把拾物等)歸還原主。 restore sb. to life 使人蘇醒過來。 be restored out of all recognition 修復得一點也認不出。
Restoring the model and msdb databases restoring the 還原model數據庫和msdb數據庫
Database restore and roll forward must be done offline 數據庫恢復和前滾必須脫機完成。
Performing a complete database restore full recovery model 執行數據庫完整還原(完整恢復模式)
Performing a complete database restore simple recovery model 執行數據庫完整還原(簡單恢復模式)
Complete database restore 這些還原方案包括:
Database restore and roll forward does not necessary require the database be shutdown 數據庫恢復和前滾不一定要求關閉數據庫
Users can access databases when a partial database restore is being performed of a database file or page 用戶在對數據庫文件或頁執行數據庫部分還原時可訪問數據庫。
The following actions to the table are considered changes : insert , update , delete , index rebuild or defragmentation , and database restore or attach 對表的以下操作可視為更改:插入、更新、刪除、索引重建或碎片整理以及數據庫還原或附加。
Remember , a full database restore will require exclusive use for the entire restore operation , whereas online restore of a table space will only require that tablespace to be in exclusive mode 記住,完全數據庫恢復將要求整個恢復操作具有排它性,而表空間的聯機恢復將只要求表空間處于排它模式中。
In sql server 2005 , the partial option performs safety checks that are omitted by the partial database restore ; therefore , the resulting database is suited for use as a production database Partial選項只能出現在順序內的第一條還原語句中。在后續的還原語句中使用partial將啟動一個新的段落還原方案。